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

Please look at this...

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

    can you share sample data and will get back to you with solution. I got what you want but with sample data it is easy to perfom the steps :)

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

      Im not sure how to upload the actual file but here is a screenshot. I would want to use the value in Column D Row 2, parse out the word Alabama, and create a new column with the word Alabama in it. 

       

       

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

        Can you share the file using google drive or dropbox