Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-12-14 01:52 PM

MongoDB to Excel

I am pulling data from MongoDB using tMongoDBInput and displaying using tLogRow component and it's working fine. But When I try to import the data out tMongoDBInput the output excel is not opening. I am getting error "Excel can't open because file  format or the extension is not valid." Please let me know what could be the issue.

Labels (2)
Labels
873 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2018-12-17 09:12 AM
Author

Thanks Nikhil.

Actually I did try all of this and neither excel or csv was working. However I did found the soulution. I used following to fix and hereafter I can open the excel with imported Mongodb data. Thanks for your help. Not sure if this issue is because of Excel or what.

 

Fix 1. Change the Excel File Extension
Step 1. Open Microsoft Excel and go the File tab.

Step 2. Click Export and choose Change File Type

Step 3. Change the file extension to .xlsx. Check if Excel can open your file or not.

 

View solution in original post

873 Views
0 Likes
13 Replies
Anonymous
Not applicable
‎2018-12-14 02:06 PM
Author

Hi,

 

   Could you please share the job screen shots and the schema screenshots you are using to extract data from MongoDB? 

 

Warm Regards,

 

Nikhil Thampi

645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 02:13 PM
Author

Hi Nikhil,

 

Attached are the shots for job desing and tFileOutputExcel properties.

 

Thanks

Chandra


Mapping.PNG
tFileOutputExcel.PNG
645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 02:21 PM
Author

Hi,

 

    I am actually interested in the column list in the schema which you have created in tMongoDBInput.

 

Warm Regards,

 

Nikhil Thampi

645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 02:31 PM
Author

Sorry forgot to attache schema. here it is.


Schema.PNG
645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 02:34 PM
Author

I have just one column called name.


column.PNG
645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 02:39 PM
Author

Hi,

 

    Could you please show the values in inside schema as shown in screenshot?

0683p000009M1hi.png

 

 

I assume it has been currently configured as Object type. Could you please check it?

 

Warm Regards,

 

Nikhil Thampi

645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 02:55 PM
Author

Nikhl,

 

Attahed is shcema with colum. Please let me know if you need anything else.

 

 

 


Schema in tMongoDBInput .PNG
645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-14 03:17 PM
Author

It's configured as String.

645 Views
0 Likes
Anonymous
Not applicable
‎2018-12-15 03:03 PM
Author

Hi Nikhil,

 

Did you find anything that will fix the issue? Please let me know if you need anything else from me.

Thanks

Chandra

 

645 Views
0 Likes