Forum Discussion

aditya_gupta41's avatar
aditya_gupta41
Contributor
2 years ago

Extracting value based on key field

Hello Experts, Below is the Input schema for my data: My objective is to extract value of ntgr where value of key = 'xyz' Thanks in Advance
pranil2k2's avatar
pranil2k2
Contributor
6 years ago

In Mapper i have two columns, and i need to configure in mail to show the table name and its stats.

I am trying using below template as suggested in document but it is throwing error. is there any standard format to refer other than below?

SMRT Load Stats

Table Name

+$$Table_name+

    <p>Table Stats</p> 
    <p>+$Table_Record_Count+</p>

Thanks Again

  • dimche_saveski's avatar
    dimche_saveski
    New Contributor III
    6 years ago

    Hello @skodali

    I tested a bit with your issue and come up with some solution. Please check this pipeline and the csv test file, and see if that can help you.
    test2_2020_06_12.slp (8.8 KB)

    and csv file structured like screenshot bellow

    BR
    Dimche Saveski

    • skodali's avatar
      skodali
      New Contributor III
      6 years ago

      Hello @dimche.saveski
      I’m trying to get those results into a single target path.
      Similar to this image

      • dimche_saveski's avatar
        dimche_saveski
        New Contributor III
        6 years ago

        @skodali

        I’ve updated the example pipeline in the post above to achieve the desired json structure, please check it

        BR