Forum Discussion

admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Column Value based upon Cell (parsed)

I am using the folder data connection to bring in multiple excel workbook (specific sheet). Each one needs some basic cleanup but most importantly I need to add a column based upon the value in Row1 ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    here you go my friend.

admiralman's avatar
admiralman
Icon for Advocate II rankAdvocate II
8 years ago

Could you provide the excel file you used?

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

here you go my friend.

  • admiralman's avatar
    admiralman
    Icon for Advocate II rankAdvocate II
    8 years ago

    Thank you...I need to approach this a different way and I succeeded using M but your solution pointed me in the right direction.