Converting Tree Structure Hierarchy to Flat File

[Ragini1]

Hi All,

I have to convert the below format to a flat file structure. How can I do that? Can someone pls help?

TRIAL_BAL - Total TB
├─────────────────────────	TOT_ASSETS - Total Assets
│	├─────────────────────────	TOT_CUR_AS - Current Assets
│	│	├─────────────────────────	TOTAL_CASH - Cash and Cash Equivalents
│	│	│	├─────────────────────────	CASH_ACCTS - Cash
│	│	│	│	├─────────────────────────	1000001000 - ABC
│	│	│	│	├─────────────────────────	1000002000 - XYZ
│	│	│	│	├─────────────────────────	1000003000 - QWE
│	│	│	│	├─────────────────────────	1000004000 -JKL

[Amol_Telore]

Hey @Ragini1 

I am not quite sure if I understand your requirement completely. Could you share snapshot of how output data would look like after converting it to flat file.

[Ragini1]

Hi Amol,

This is how the output should look like.

TRIAL_BAL - Total Trial Balance	TOT_ASSETS - Total Assets	TOT_CUR_AS - Current Assets	TOTAL_CASH - Cash and Cash Equivalents	CASH_ACCTS - Cash	1000001000 - ABC
TRIAL_BAL - Total Trial Balance	TOT_ASSETS - Total Assets	TOT_CUR_AS - Current Assets	TOTAL_CASH - Cash and Cash Equivalents	CASH_ACCTS - Cash	1000002000 - XYZ
TRIAL_BAL - Total Trial Balance	TOT_ASSETS - Total Assets	TOT_CUR_AS - Current Assets	TOTAL_CASH - Cash and Cash Equivalents	CASH_ACCTS - Cash	1000003000 - QWE
TRIAL_BAL - Total Trial Balance	TOT_ASSETS - Total Assets	TOT_CUR_AS - Current Assets	TOTAL_CASH - Cash and Cash Equivalents	CASH_ACCTS - Cash	1000004000 -JKL

[OllieClarke]

@Ragini1 

How's this:

n.b. I'd turn amp off for this workflow as record order does in fact matter

Hope that helps,

Ollie