If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Append to data module

Started by therese1, 17 Oct 2017 02:57:06 AM

Previous topic - Next topic

therese1

Is there any way to append uploaded excel file to a data module?


Sent from my iPhone using Tapatalk

MFGF

Quote from: therese1 on 17 Oct 2017 02:57:06 AM
Is there any way to append uploaded excel file to a data module?


Sent from my iPhone using Tapatalk

Hi,

Can you clarify the question? Do you mean can a newly uploaded Excel file be added to an existing data module, or do you mean you have a data module already including the uploaded Excel file and you want to re-upload the file adding new data?

MF.
Meep!

therese1

Quote from: MFGF on 17 Oct 2017 06:13:04 AM
Hi,

Can you clarify the question? Do you mean can a newly uploaded Excel file be added to an existing data module, or do you mean you have a data module already including the uploaded Excel file and you want to re-upload the file adding new data?

MF.
Hi MF,

Sorry for not being clear... newly uploaded Excel file to be added to existing data module


Sent from my iPhone using Tapatalk

MFGF

Quote from: therese1 on 17 Oct 2017 06:15:32 AM
Hi MF,

Sorry for not being clear... newly uploaded Excel file to be added to existing data module


Sent from my iPhone using Tapatalk

Hi,

Yes - easily. Just open the data module and add a new data source in the pane on the left :)

MF.
Meep!

therese1

Quote from: MFGF on 17 Oct 2017 06:16:45 AM
Hi,

Yes - easily. Just open the data module and add a new data source in the pane on the left :)

MF.
Thanks MF ... oh man I was think of like a report appending to bottom of previously uploaded file. Sorry thinking wrong way.

K I did this then tried to join there are 60 files of mnth yr with same format but the join didn't seem to work?


Sent from my iPhone using Tapatalk

MFGF

Quote from: therese1 on 17 Oct 2017 06:22:02 AM
Thanks MF ... oh man I was think of like a report appending to bottom of previously uploaded file. Sorry thinking wrong way.

K I did this then tried to join there are 60 files of mnth yr with same format but the join didn't seem to work?


Sent from my iPhone using Tapatalk

Do the data types of the join items match?

MF.
Meep!

therese1

Quote from: MFGF on 17 Oct 2017 06:27:39 AM
Do the data types of the join items match?

MF.
Yes they are exactly the same. So not sure I cannot join them.


Sent from my iPhone using Tapatalk

MFGF

Quote from: therese1 on 17 Oct 2017 06:39:33 AM
Yes they are exactly the same. So not sure I cannot join them.


Sent from my iPhone using Tapatalk

Can you explain what exactly happens when you join the new file into the data module?

MF.
Meep!

therese1

Hi So sorry taken so long to answer been over seas, solved it was my error... thank you for help