Forum Discussion

sanam's avatar
sanam
New Contributor
6 years ago

Router configuration

Hi Team,

I need some help in router configuration.
I have snap execute where we select data and want to push to different target tables based on theater column.
how to put the condition
theater=‘America’ in the router.

14 Replies

  • cstewart's avatar
    cstewart
    Former Employee


    This pipleine does what you want I think. I put the inoput data in the CSV generator at the beginning, and the output of the join give the data you need.
    Take a look.

    Group_test_2019_03_23 (1).slp (23.7 KB)

    • arvindnsn's avatar
      arvindnsn
      Contributor

      Thanks for the Solution. The Solution is almost what i need except the "Transaction_id should be displayed at the header level only. “The tenders” child array also displays the “TRANSACTION_ID” attribute which i don’t want to display at the tenders level.

      I tried removing by having empty expression variable for “transactiod_id” in the “Remove groupBy tenders” Snap but didn’t work. It would be really helpful if this is sorted.

      Thanks

  • arvindnsn's avatar
    arvindnsn
    Contributor

    receipt_no,item_id,quantity,item_total,item_gross,item_tax are item attributes grouped for each transaction_id.

    media_id,media_no,media_value are tenders attributes grouped for each transaction_id