Hello all,
I have attached the files, Test 2 is what I currently have after inputting a directory of files from a folder (because they are JSON files) and I want them to be like Test 3 file. But on the file Test 2 it has all the titles on the Name column and all of the data on the ValueString column. There are more files but I am only using a small number of files to make it easier. And from the files as you can see their are files that have more columns then the others.
Is there any way to make file Test 2 to equal Test 3 using Alteryx? I have a way but it is slow, and quite a hassle (by bringing each file individually and fix them and then merge them together but there is like 20 files)
Solved! Go to Solution.
Thank you so much! I didn't even think that way as a solution! @gabrielvilella