MalcolmMcDonald
3 years agoQrew Cadet
Grouping and Listing fieldnames and values in Pipelines
I'm importing a flat file of workorders into a staging table, then looking to load it into the production tables.
The file has about 24 columns of parts that could be installed, with a count. Looks a bit like the below:
DOORBELL CAMERA | INDOOR CAMERA | OUTDOOR CAMERA | TAKEOVER MODULE | DOOR/WINDOW SENSOR |
1 | 2 | |||
1 | 1 | 2 |
I'm not using this data for inventory .. it's purely informational.
Using pipelines - is there an easy way put all those columns into a single multi-line text block, separated into a list - skipping over the blank ones? EG -- that first record would like the below or similar:
Doorbell Camera: 1 | Door / Window Sensor: 2
Thanks!
------------------------------
Malcolm McDonald
------------------------------