Text file attribute to Excel file.
Dear All,
I have big text file Like shown below as sample
Name / Company 01
Location : ABC
TYPE : A
Name / Company 02
Location : DEF
TYPE : Industry
Category : Production
Name / Company 03
Location : DEF
TYPE : Industry
Category : Production
ManagerID : 01
The expected output like shown below,
Name,Location,Type,Category,ManagerID
Company 01,ABC,A
Company 02,DEF,Industry,Production
Company 03,DEF,Industry,Production,01
In above in each company there are many new attributes available (around 100+)
Please advise.
Thanks
Venu
Hi @venu, I think this workflow does the trick. Assuming that each destination feature always starts with "Name" entry.
text-to-table.fmwt (FME 2018.1.0.3)
FME processes features one by one until meeting a blocking transformer. Hopefully this table helps you to understand how the workflow works.
| text_line_data | Tester | Counter | VariableSetter | VariableRetriever |
| Name / Company 01 | Passed | _feature_id = 0 | vFeatureId = _feature_id | |
| Location : ABC | Failed | _feature_id = vFeatureId | ||
| TYPE : A | Failed | _feature_id = vFeatureId | ||
| Name / Company 02 | Passed | _feature_id = 1 | vFeatureId = _feature_id | |
| Location : DEF | Failed | _feature_id = vFeatureId | ||
| TYPE : Industry | Failed | _feature_id = vFeatureId | ||
| Category : Production | Failed | _feature_id = vFeatureId | ||
| Name / Company 03 | Passed | _feature_id = 2 | vFeatureId = _feature_id | |
| Location : DEF | Failed | _feature_id = vFeatureId |
