Hi! I am trying to split a column based on the variable in another column. I have a dataset that mixes file paths with file names. I only want to split file paths that have files in them (indicated by the "Item Type" as Files). I think I need an if-statement and Text.Split. The green table indicates where I am starting and the orange one indicated where I want to end at.