Hello Team -
I’m scratching my head over this one. I have a simple example in the link below. What is the best API workflow design that takes a list of Text or Numbers that are contain in a record and create a new “Flat File” by having all the lists items on their own row?
Please see the editor link below for a simple example. Here is the scenario:
Data Type: Hotel Guest ===> This is the Input or current structure
-Name
-DOB
-From City
-License_Plate
-InRoom-Bar_orders_item [List]
-Quantity (of Bar_Order_items) [list]
Data Type: Hotel_Guest ===> This is the output “Flat File” after running API workflow
-Name
-DOB
-From City
-License_Plate
-Bar_Order_items
-Quantity (of Bar_Order_items)
The original list of Bar_Order_items and matching quantity are converted to their own individual row, then saved with the Name, DOB, From City, License_Plate of the hotel guest
The print screen below is the API workflow that I’ve setup. Is there a method or :command that I can use that takes all the items in the list and creates a new row? Should I be using RegEX for this? I’ll be setting this up as an API workflow given there will be thousands of records.
Please Advise
Link to Editor:
https://d39.bubble.is/site/text-to-row/version-test/