Hi, All the data from a Database come in one. What is the best way to Parse it? The data to parse is in the file - Data to Parse. Please note that the data needs to inputted in one cell as I am getting this data from download tool in Alteryx. I can't output this and re-import using input tool so please help me without any formatting in input tool. The final data should look like this. TB codeDocument NoAmountDateTypeDescriptionDetailsText200-192-0053177108-600001/04/2022FOSBREAKDOWN REB P3Qtr 1 2022 Rebate0F000200-192-0053177108-400001/04/2022FOSBREAKDOWN REB P3Qtr 1 2022 Rebate0F000200-192-0053177108-700001/04/2022FOSBREAKDOWN REB P3Feb 22 Rebate0F000200-192-0053177108-700001/04/2022FOSBREAKDOWN REB P3Mar 22 Rebate0F000 Data to Parse.csv

Parse the data in one cell

Hi,

All the data from a Database come in one. What is the best way to Parse it?

The data to parse is in the file - Data to Parse. Please note that the data needs to inputted in one cell as I am getting this data from download tool in Alteryx. I can't output this and re-import using input tool so please help me without any formatting in input tool.

The final data should look like this.

TB code	Document No	Amount	Date	Type	Description	Details	Text
200-192-005	3177108	-6000	01/04/2022	FOS	BREAKDOWN REB P3	Qtr 1 2022 Rebate	0F000
200-192-005	3177108	-4000	01/04/2022	FOS	BREAKDOWN REB P3	Qtr 1 2022 Rebate	0F000
200-192-005	3177108	-7000	01/04/2022	FOS	BREAKDOWN REB P3	Feb 22 Rebate	0F000
200-192-005	3177108	-7000	01/04/2022	FOS	BREAKDOWN REB P3	Mar 22 Rebate	0F000

Data to Parse.csv

Data Investigation

Accepted answers

Yoshiro_Fujimori

@Data_Alter ,

Assuming that you want to get the data in one cell once, and then parse it to columns later,

I would input the CSV file as BLOB and then convert to text as below.

The rest of the work is similar to others community members.

I hope this helps.

Workflow

ParseOneCell.yxzp

All comments

Prometheus

In my Input Data tool, I chose to use no delimiter (\0) because I was getting errors inputting the data. Then I used the Text to Columns tool and used the pipe (|) delimiter to split DownloadData to 8 columns. After that, I used the Dynamic Rename tool and renamed all the columns with the first row of data. A Select tool came after that because "TB code" came in as "?TB code," so I renamed it without the "?". Finally, I used a Filter tool to only allow records where the Document No was not null.