Converting Tree Structure Hierarchy to Flat File
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Ragini1
8 - Asteroid
‎08-08-2022
04:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Labels:
- Labels:
- Parse
3 REPLIES 3
Amol_Telore
11 - Bolide
‎08-08-2022
11:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎08-09-2022
05:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
15 - Aurora
‎08-09-2022
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How's this:
n.b. I'd turn amp off for this workflow as record order does in fact matter
Hope that helps,
Ollie
