Parse the data in one cell

[Data_Alter]

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

[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.

 

 

 

[Felipe_Ribeir0]

Hi @Data_Alter 

Try the attached workflow

[Data_Alter]

Thanks, the data is coming from download tool so I can't use input tool. This needs to be parsed without the input tool.

[Felipe_Ribeir0]

Hi @Data_Alter 

Try the version, it is using just text.

[Prometheus]

If that's the case, just replace the Input Data tool with your workflow up to the Download tool. What comes out of the Input Data tool is the same data that's coming out of your Download tool.

[Yoshiro_Fujimori · Accepted solution]

@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