Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transformer different rows of 1 column into multi column

Hi folks,   A have a Excel Q&A Database with multiple questions and answers in differente sheets from diffentes people/companies, as example in below link to download from "mega.nz".   https://m...
Need Help
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

 

It's possible, you need to use Folder connector and apply all transformations on the file you used as example. So, it will be applied to all tables and append later.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi camargos88 ,

Unfortully, I don't know how to make this tranformation in the rows for each Question/Subquestion/optiond in the columns, and create the coloumns  in the sample file/table to applie in other queries.

 

 

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

     

    Can you provide some file sample, with dummy data ? 

    So I can replicate it from my side with multiples files.