Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Table.Pivot - Pivoted Column - dealing with duplicates

I'm exporting data out of a jotform. The form is for daily inventory counts. The counts are coming in specitic to warehouse Location and Bin (a location can have multiple bins). For example, item aa...
Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    At step4) -    "4) generalize the [Attribute] column into values containing either "Location" or "Count".",

    if you split the column from non-digit to digit and leave both columns in place, you can do the Pivot with "Don't aggregate".  There shouldn't be any errors at that point.

    You can then sort out the datatypes, maybe remove columns and probably do a 'Group By' to get what you want

HotChilli's avatar
HotChilli
Community Champion
3 years ago

At step4) -    "4) generalize the [Attribute] column into values containing either "Location" or "Count".",

if you split the column from non-digit to digit and leave both columns in place, you can do the Pivot with "Don't aggregate".  There shouldn't be any errors at that point.

You can then sort out the datatypes, maybe remove columns and probably do a 'Group By' to get what you want