I want to change column names in multiple data files to distinguish each file's name

Hi,
I want to change column names in multiple data files to distinguish each file’s feature.

image

I used this Work-flow to distinguish each file’s feature.

After I combined the format, The result was…

image

image

image

But, I want to change column names to file’s name, such as


There is file’s name like “MTBAK44 BAD”, So, I want to change ChamberPressure (Iter #2) to
ChamberPressure MTBAK44 BAD.

But, I don’t know how can do it.
Please let me know…

Thank you.

One approach is to extract all the file names after using the List Files node, then, for each file

  1. Read the file
  2. Extract column headers
  3. Create new column headers by joining the existing column headers with the file name
  4. Update column headers
5 Likes

Thank you so much.
I try to solve this problem by using your comment.

I’m sorry, I can’t understand using “Get FileName” Node…

Please let me know…

Thank you…

Did you open it and look inside?
Is there something specific that you don’t understand?

It’s just a collection of nodes that extracts the filename from a url. I used Regex to do this, but there are other options. You’ll probably have to customize it to fit your specific needs.

Thank you!!

Thanks to you, I could solve this problem!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.