Forum Discussion

Karan_Mhatre's avatar
Karan_Mhatre
New Contributor II
7 years ago

Can We create a Variable in Mapper

Hello Everyone, I am trying to create an incremental addition let say i have 2 columns empl_id and salary so in target i want to derive third column with cumulative salary. I can do it by using v...
vsuresh's avatar
vsuresh
New Contributor
6 years ago
Copy LinkReport

I have an input value of string datatype. It has values 0,1,2,3,4 and blanks( empty values). I want to convert this to datatype int for the numbered values and the blanks I want to convert to NULL value since the field in the table takes NULL values. Please let me know if this makes sense.

Thanks

  • vineesha's avatar
    vineesha
    Employee
    5 years ago
    Copy LinkReport

    Hi,

    is the Single document output checked in the in-memory lookup snap settings?

    • kamalaker_pinna's avatar
      kamalaker_pinna
      New Contributor
      5 years ago
      Copy LinkReport

      Hi Vineesha,

      Yes, it is set as Single Document output. However, the issue we encounter is in the Input JSON itself. As we are receiving multiple input for JSON, In memory lookup is taking time.

      Thanks,
      Kamal

      • vineesha's avatar
        vineesha
        Employee
        5 years ago
        Copy LinkReport

        Did you try having the In-memory lookup snap in a child pipeline? As it provides Limited support in Ultra Pipelines when the Single document output field is selected.