Hi Everyone,
I'm running into an issue when pulling data from an excel file. Basically I am trying to pull in the data and use a Transform stage to split out rows if certain cells are empty. When I debug this I can see the incoming value from the excel file for these shows as <NULL>, I would assume I could then therefore use a constraint like IsNull(Link.Cell) and map in the columns. Unfortunately I can't get it to trigger. The incoming columns are set as Nullable, and the outgoing of the main link has them set to not nullable. The second link where I have the contraint and I'm trying to catch rows with null values, has the columns set as nullable.
I've tried other variations as well, (link.cell = 0), (link.cell = ''), etc. Does anyone have any ideas?
IsNull() from Excel data issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 145
- Joined: Thu Oct 26, 2017 10:43 am
Re: IsNull() from Excel data issue
Check with the system whoever is creating the excel if they are correctly populating the NULL Values (or Add Constraint <> '<NULL>' and see if the data is getting Filtered out by the constraint. I tried sample ds job to create unstructured data with 1 Column as NULLABLE Yes and set to SETNULL() and those rows got successfully filtered out in next job if add constraint: ISNULL(Column)
Venkata Srini
-
- Premium Member
- Posts: 145
- Joined: Thu Oct 26, 2017 10:43 am