Forum Discussion

salishrodinger's avatar
salishrodinger
New Contributor II
2 years ago
Solved

Conditional Snap Run

Hi everyone, I have been experiencing an issue lately where I have a large zip file containing 17 CSV files. I unzip the file and write it into an external stage. After that, I run several procedure...
  • marjan_karafilo's avatar
    marjan_karafilo
    4 years ago

    Hi @RoyB ,

    I have attached sample pipeline, please try it and let me know if it helps you.

    CSV to TXT pipeline_2022_02_28.slp (8.4 KB)

    The thing is that in the “Mapper” we set content-type to text/plain in order to save the file as .txt

    BR,
    Marjan

jovan_j's avatar
jovan_j
New Contributor III
6 years ago
Copy Link

Hi skodali,

In the account reference you can use pipeline parameters. Please check the link for more details.

To write multiple conditions you can use the ternary operator.
The expression which you have specified can be replaced with ternary operator as following:
_a ==1 ? “shared/INT” ?(_a ==2 ? “shared/Goods” ? (_a ==3 ? “shared/NAM” : “OtherAcct”): “OtherAcct”) : “OtherAcct”
Or additionally you can use the match control operator, with this operator you can get:
match _a {
1 => ‘shared/INT’,
2 => ‘shared/Goods’,
3 => ‘shared/NAM’,
_ => ‘OtherAcct’
}

Regards, Jovan.

skodali's avatar
skodali
New Contributor III
6 years ago
Copy Link

Thanks Jovan, this helps a lot.