Loading Excel spreadsheet with four worksheets

[#1]

Hi,

I have one spreadsheet with four work sheets, each worksheet contains unique information, but the structure (columns/names) is 95% same, only a few filed were added to two of the worksheets.

Use quick load, selected all worksheets, load the data.

Created a new sheet, added a Bar Chart, added dimension and measure, applied filters to a specific value which occurs only in one of the worksheets 5 times, however the value presented in the bar chart 15 (3 times what should be)

Open Data Modeler; find out that there are 3 tables. One of them contains the merger of all three. That is why the value in the bar chart shows 3 times what it should be.

How can I eliminate the triple count?

Thank you - Mauricio

[sinanozdemir]

Your image files seem empty...

[kangaroomac]

Not sure if this has been answered already, if so, please mark it answered.

Are you just loading the 4 tables you wish to concatenate (recommended for testing purposes)?

If so, the Syn tables are an indication that there may be something wrong with your concatenation (i.e. field names that differ, etc.)

To remove "Extra" or redundant values, you have a few options:

• Use MaxString in your front-end expression
• Use Avg in the front-end if you use Count
• In the load script use where not exists(Test1) as a where clause for file 2 to 4
  • i.e. if the value 'High1' is loaded for the Field Test 1 in Table1 already, even if the field entry exists in Table2, with the above clause it won't load again (with other words you'll only have distinct values in your concatenated table).