Assistance requested creating pipeline for SQL query-->mapper-->text file

[wahlborn]

My goal is to execute a SQL query, return data, and format it so that it is accepted by a custom app we run here. So far, I have extracted the necessary data and formatted it using a mapper. The mapper output contains three columns that I need to move into a text file. For example:

ColumnA ColumnB ColumnC ColumnD ColumnE
DataA1 DataB1 DataC1 DataD1 DataE1
DataA2 DataB2 DataC2 DataD2 DataE2
DataA3 DataB3 DataC3 DataD3 DataE3

I need to output the data from the last three columns in the following format and create a text file:

DataC1
DataC2
DataC3
DataD1
DataD2
DataD3
DataE1
DataE2
DataE3

I’ve tried a handful of different snaps, and I haven’t succeeded in getting it to work. Anyone have tips on how to implement this?

[Supratim]

@wahlborn

The easiest way (but not professional way) to do this-
1.use copy snap and make three output view.
2. use one mapper with value of CloumnC and count var=1. (make use target value for all ColC,ColD,ColE should remain same. )
3. use one mapper with value of CloumnD and count var=2
4. use one mapper with value of CloumnE and count var=3
5. Use union to marge all 3 views.
6. Use sort snap by count variable.

[wahlborn]

Thank you! Can you explain further; I don’t know what you mean by implementing a count variable?

[Supratim]

TestData.slp (12.9 KB)

@wahlborn Please use the attached pipeline.