Forum Discussion

DeltaMetal's avatar
DeltaMetal
New Member
4 years ago

If a Condition is met then Custom Column is not generated

Hi   I am trying to create multiple custom column based on Text Split. How do I place a condition that says that if the number is higher than max value of another column in this caase Comma Numbers...
Need Help
Ehren's avatar
Ehren
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Yes, you can do this by using an if expression to return previousStepName instead of Table.AddColumn(previousStepName, ...) when a condition is met.

 

Can you describe the high-level goal you're trying to accomplish with all these splits and conditionals?

  • DeltaMetal's avatar
    DeltaMetal
    New Member
    4 years ago

    Hi

    We have a column with string of data separated by commas. There in no maximum limit on this string and we will need to reconcile this data biweekly. In process of creating the reconciliation file we need the same 4 repeating set of data in the string. The process as shown in the image.

    We were hoping if there is any way to make it dynamic so as to stop the creation of extra columns when data is not present?

    Also, if there is a more efficient way for this that you can point to it will be greatly appreciated.

     

    P.S. – We are using Microsoft 365 and we are not seeing TEXTSPLIT as formula option.