Is there any way to append uploaded excel file to a data module?
Sent from my iPhone using Tapatalk
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.
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
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.
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
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.
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
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.
Hi So sorry taken so long to answer been over seas, solved it was my error... thank you for help