I need help with data transforamation

[Newtoalteryx]

Table 1 and 2 are my inputs and I need to figure out a way to generate the desired output. Please let me know if it's possible. Thanks!!

[apathetichell]

You want the desc concatenated in your ouptut - no? what you are showing here is just table 2 with | replaced by comma... The way do what you want:

1) recordid - table2.

2) text to columns (table 2) - split to rows, | is your delimiter.

3) join citation on citation.

4) summarize - group by record id, concatenate desc.

5) join resulting table to original table2 from step 1 via recordid field

[Newtoalteryx]

Sorry for the mistake. I edited my file. Can you please guide me on how to proceed now?

[Newtoalteryx]

Sorry for the mistake. I edited my file. Can you please guide me on how to proceed now?

[apathetichell]

Follow the steps I laid out - that was my assumption.

[Newtoalteryx]

Hey,

I am running into a problem while summarizing the data.  I want to group my data by site_id, inspection start and end date. Please let me know if I am doing something wrong. Thanks!

[apathetichell]

No - if nothing is being group together then you have unique values cross those 3 fields.