[resolved] Graph on Excel disappeard when i run my job

[Anonymous]

Welcome everybody,
here is my job:



the problem is when i run my job, my Excel file is update, so we can see in my Excel a table with data but my graph that i create before in the same Excel disappear.

Is there anyone who can help me please?

[Anonymous]

it looks helpful

[Anonymous]

Hi 

   How to access google big query table from talend 
    big query table was  created with URL google spread sheet source. where in the details section you can find no preview is not available as like other big query tables.

 


 How to access tbigqueryinput component in that case. I got some error which shows talend component is not recognising  data
error details:

{
  "code" : 404,
  "errors" : [ {
    "domain" : "global",
    "location" : "table_reference",
    "locationType" : "other",
    "message" : "Not found: {0} {1}",
    "reason" : "notFound"
  } ],
  "message" : "Not found: {0} {1}"
}
Exception in component tBigQueryInput_1
com.google.api.client.googleapis.json.GoogleJsonResponseException: 404 Not Found
{
  "code" : 404,
  "errors" : [ {
    "domain" : "global",
    "location" : "table_reference",
    "locationType" : "other",
    "message" : "Not found: {0} {1}",
    "reason" : "notFound"
  } ],
  "message" : "Not found: {0} {1}"
}

How to use big query table in that case ??