{"id":"bae9fc66-1075-4743-a4f5-9a494dbff71b","brandColor":"#8C3900","connectionReferences":{},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iMCAwIDMyIDMyIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPg0KIDxwYXRoIGQ9Im0wIDBoMzJ2MzJoLTMyeiIgZmlsbD0iIzhDMzkwMCIvPg0KIDxwYXRoIGQ9Im04IDEwaDE2djEyaC0xNnptMTUgMTF2LTEwaC0xNHYxMHptLTItOHY2aC0xMHYtNnptLTEgNXYtNGgtOHY0eiIgZmlsbD0iI2ZmZiIvPg0KPC9zdmc+DQo=","isTrigger":false,"operationName":"Split_Column_Sample","operationDefinition":{"type":"Scope","actions":{"SampleData":{"type":"Compose","inputs":[{"Created":"01-01-2025","TestColumn":"Inv10001|Inv10002|Inv10003"},{"Created":"02-10-2025","TestColumn":"Inv10004|Inv10005|Inv10006"},{"Created":"03-20-2025","TestColumn":"Inv10007|Inv10008|Inv10009"},{"Created":"04-28-2025","TestColumn":null},{"Created":"05-05-2025","TestColumn":""}],"runAfter":{},"metadata":{"operationMetadataId":"cbd25700-ee7f-4978-af0d-2ab61bc44f59"}},"Split_Column":{"type":"Scope","actions":{"SplitSettings":{"type":"Compose","inputs":{"Column":"TestColumn","Delimiter":"|","Data":"@outputs('SampleData')"},"runAfter":{},"description":"Enter the column name to split on, the delimiter in the column values to split on, and the JSON array containing the data & column to split","metadata":{"operationMetadataId":"b4fa35f3-8585-4ad2-985c-7ef837f3e624"}},"Filter_array_Get_blanks":{"type":"Query","inputs":{"from":"@outputs('SplitSettings')['Data']","where":"@or(equals(item()?[outputs('SplitSettings')['Column']], null), equals(item()?[outputs('SplitSettings')['Column']], ''))"},"runAfter":{"SplitSettings":["Succeeded"]},"metadata":{"operationMetadataId":"1e021f54-1620-47f1-89ac-731795e4766f"}},"Select":{"type":"Select","inputs":{"from":"@outputs('SplitSettings')['Data']","select":"@if(empty(item()?[outputs('SplitSettings')['Column']]), null, concat(join(split(item()?[outputs('SplitSettings')['Column']], outputs('SplitSettings')['Delimiter']), concat('~|`', item(), '*#~')), '~|`', item()))"},"runAfter":{"Filter_array_Get_blanks":["Succeeded"]},"metadata":{"operationMetadataId":"eb604ba4-e8ce-46f4-92a6-25e2733160b0"}},"Filter_array_Remove_blanks":{"type":"Query","inputs":{"from":"@body('Select')","where":"@not(equals(item(), null))"},"runAfter":{"Select":["Succeeded"]},"metadata":{"operationMetadataId":"cc716bc1-baef-4281-a8cb-98fd12d9621e"}},"Select_2":{"type":"Select","inputs":{"from":"@split(join(body('Filter_array_Remove_blanks'), '*#~'), '*#~')","select":"@setProperty(json(split(item(), '~|`')[1]), outputs('SplitSettings')['Column'], split(item(), '~|`')[0])"},"runAfter":{"Filter_array_Remove_blanks":["Succeeded"]},"metadata":{"operationMetadataId":"e6e56838-8e95-4053-8efb-cf674d9410e8"}},"MergeWithBlanks":{"type":"Compose","inputs":"@union(body('Select_2'), body('Filter_array_Get_blanks'))","runAfter":{"Select_2":["Succeeded"]},"metadata":{"operationMetadataId":"31e23a2f-7946-4b7b-b7d4-34102f4ea12b"}}},"runAfter":{"SampleData":["Succeeded"]},"description":"Enter inputs in the SplitSettings action, get outputs from the MergeWithBlanks action","metadata":{"operationMetadataId":"6c90ba85-139c-4ccc-8c80-639029e4b67e"}}},"runAfter":{},"metadata":{"operationMetadataId":"81cfedfe-a9e6-49a9-8023-a2304466c199"}}}