Lookup transform table options

Is it possible to generate the table values (not keys) dynamically in a transform?

For example:

{
  "attributes": {
    "table": {
      "512": "Austin",
      "281": "Houston",
      "214": "Dallas",
      "210": {
               "type": "substring",
                "attributes": {
                  "input": {
                    "type": "accountAttribute",
                    "attributes": {
                      "attributeName": "first_name",
                      "sourceName": "Example CSV Source"
                    }
                  },
                  "begin": 0,
                  "end": 1
             },
      "default": "Unknown Area"
    }
  },
  "type": "lookup",
  "name": "Lookup Transform"
}

@josephcasale

Yes, you can read dynamically. I did this multiple times…!

To test, retrieve the accountAttribute just as below:

"210":{
       "attributes": {
                                "attributeName": "first_name",
                                "sourceName": "Example CSV Source"
                            },
                            "type": "accountAttribute"
}

Then apply a substring!

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.