How to read sub columns in Excel?

Help Studio
, ,
4

Heres a sequence that turns your table to a single-row header, so you can process it normally e.g. the first column will be called “Loc-Location-Current”, 2nd column “Loc-Location-New” and so on…
Sequence.xaml (28.6 KB)

image

when you use the sequence, you have to change the excel path and sheet names accordingly
image

1 Like