I am importing a CSV file into PQ.
No problem with the import, but the problem is 2 columns have the text in a "wrap" format. This means that the value in another column does not appear in PQ and only the first line of the wrapped text shows.
Is there a way to unwrap columns in PQ?
What exactly do you mean by text in "wrap" format? Can you upload and example of a CSV file with such data?
I mean text is like in excel if you enter text in a cell and click the Wrap button on ribbon.
The CSV file is attached.
Filter Name column for Agga, then look in Description column.
The only workaround I can think of is to save the csv file as xlsx, then select the Description column and unwrap all rows, then save back to csv. That works but I was hoping to avoid that and do the "unwrap" directly on the csv file in PQ.
The CSV didn't come through. Please try again. This time don't forget to press 'Start upload' and wait until it's complete before submitting your reply.
The file was too big for upload to be accepted.
I will reduce a load of unused columns and about 6000 rows and try again.
Understood!!
Here is the file reduced from 2,200kb to 44kb
The wrapped text is in column B
The actual file has 7,500 rows and 80 columns.
This is what I see when I connect PQ to the CSV, columns A and B. It all seems to line up pretty good, though it probably need som work to clean it up.
What do you see?
Everything seems ok with the sample file, but that is not the same with the actual file.
I will investigate some more and come back with another sample file where PQ does not work.
OK
The csv file is located in a folder of similar csv files. I import the folder contents into PQ, sort "Date Created" descending to get most recent file in top row, then do a "keep top row".
I had made an error, expanded Table not Binary. Changed to expand binary and all is good.
Sorry to waste your time Riny, but at least making the sample file, and that working, made me realise my original error.
No worries!
